<!DOCTYPE html>
<!--
To change this license header, choose License Headers in Project Properties.
To change this template file, choose Tools | Templates
and open the template in the editor.
-->
<html>
    <head>
        <meta charset="UTF-8">
        <title></title>
    </head>
    <body>
        <?php
        // put your code here
        include ("../conn/conn.php");
        $conn = prepare();
        ?>
        <?php
$sql= exectue_sql_statement($conn, "select * from Classification");
$info=sqlsrv_fetch_array($sql);
 if($info==false)
  {
    echo "本站暂无图书类别!";
   }
  else
  {
?>
<div align="center">
  <table width="400" border="0" align="center" cellpadding="0" cellspacing="0">
   <form name="form1" method="post" action="deleteclass.php">
    <tr>
      <td height="20" bgcolor="#B0E0E6"><div align="center">图书类别管理</div></td>
    </tr>
    <tr>
      <td height="20" bgcolor="#666666"><table width="400" border="0" align="center" cellpadding="0" cellspacing="1">
        <tr>
            <td width="144" bgcolor="#FFFFFF"><div align="center">操作</div></td>
          <td width="253" height="20" bgcolor="#FFFFFF"><div align="center">类别名称</div></td>
        </tr>
		<?php
		  do
		  {
		?>
        <tr>
          <td height="20" bgcolor="#FFFFFF"><div align="center"><input type="checkbox" value=<?php echo $info['classify_id'];?> name="<?php echo $info['classify_id'];?>"> </div></td>
          <td height="20" bgcolor="#FFFFFF"><div align="center"><?php echo $info['classify_name'];?></div></td>
        </tr>
		
		<?php
		 }
		 while($info=sqlsrv_fetch_array($sql));
		?>
        <tr>
          <td height="20" bgcolor="#FFFFFF"><div align="center"><input type="submit" value="删除选项"></div></td>
          <td height="20" bgcolor="#FFFFFF"><div align="center"></div></td>
        </tr>
      </table></td>
    </tr>
	</form>
  </table>
</div>
<?php
 }
?>
    </body>
</html>
